home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Select (Limited Edition)
/
Computer Select.iso
/
pcc
/
v04n07
/
prepay.doc
< prev
next >
Wrap
Text File
|
1991-06-24
|
1KB
|
40 lines
PREPAY.EXE
PC/Computing
July, 1991
Stephen L. Nelson
Page 234
-----------------------------------------------------------
Find out how much you'll save by paying off a
mortgage early.
To use this template, you'll enter six pieces of data in
Part 1.
In Cell B3, enter your current mortgage balance.
In Cell B4, enter your mortgage's annual interest rate.
In Cell B5, enter your regular monthly mortgage principal
and interest payment.
In Cell B6, enter the extra amount you'd consider paying
each month.
In Cell B7, enter your marginal income tax rate as a percent.
To learn your rate, check this year's federal income tax.
For most, this will be either 15 or 28 percent. If you
live where there is state or local income tax, you'll need
to add those rates, too.
In Cell B8, enter your marginal Social Security tax rate as
a percent. In 1991, income up to $53,400 is subject to a
7.65 percent tax rate.
Material in this document may not be reproduced in any form
without permission. Written requests for permission should
be addressed to Chantal Lavelanet, Ziff-Davis Publishing
Company, One Park Avenue, New York, NY 10016.